﻿if exists (select * from dbo.sysobjects where name = 'sp_tb_Services_Update')
	drop procedure [dbo].[sp_tb_Services_Update]
Go 
CREATE PROCEDURE dbo.sp_tb_Services_Update
@Id	int,
@Name	varchar(50),
@Status	bit
AS
UPDATE tb_Services SET [Name] = @Name,[Status] = @Status
WHERE  Id= @Id
Go